SELECT COUNT(1)
FROM C1_OPERATE_LOG T
WHERE DATE_FORMAT(NOW(), '%Y%m%d') = DATE_FORMAT(T.`CREATED_DATE`, '%Y%m%d')
AND t.code = :code
AND t.type_id = :typeId
